Release 10.1A: OpenEdge Data Management:
SQL Reference

Numeric literals

A numeric literal is a string of digits that SQL interprets as a decimal number. SQL allows the string to be in a variety of formats, including scientific notation.

This is the syntax for a numeric literal:

Syntax

[ + | - ] { [ 0-9 ] [ 0-9 ] ... }     [ . [ 0-9 ] [ 0-9 ] ... ]     [ { E | e } [ + | - ][ 0-9 ] { [ 0-9 ] } ]

Example

The numeric strings in the following example are all valid:

123 123.456 -123.456 12.34E-04